Lotus 123 Level 2

Outcomes

Participants will learn how to display worksheet data by creating charts; they will also manipulate worksheet ranges by using database operations. Students enrolling in this course should understand the basics of working in a 1-2-3 for Windows worksheet.

Prerequisites

Windows (95/98/NT 4) introduction, or equivalent knowledge.
Introduction, 1-2-3 97: Worksheets (Windows 95) or 1-2-3 Millennium Edition: Worksheets (Windows 95), or equivalent knowledge

What should you be familiar with?



Session Length

1 Day, 9:00am to 4:30pm

Location

This session is conducted either on site, or at our training rooms.

Topics Covered in this session

---

Introduction to charts Creating a basic chart Working with multiple charts Formatting and enhancing charts Enhancing and formatting titles and legends Modifying axis information Using drawn objects to enhance charts and worksheets Using pie charts Creating a pie chart Enhancing a pie chart Advanced charting topics Adding and deleting a data series Additional enhancements Creating charts from 3-D ranges Sorting data One-column sorts Range names Multiple-level sorts

Introduction to data management Database terminology and guidelines Defining the database table and the find criteria Text comparison criteria Numeric comparison criteria Using query tables Working with query tables Using multiple criteria Managing records in a database table Using database functions Appendix Using maps to chart data Integration with Approach

Performance-based objectives

• Display data graphically by selecting a range and creating a chart.
• Enhance chart displays by modifying parts of the chart.
• Display data as parts of a whole by creating and enhancing pie charts.
• Enhance worksheet and chart data by using drawn objects.
• Manage data on a worksheet by sorting the rows.
• Find records in a database table by using a query table.
• Manage data in a database table by using a query table.